Instead of your Microsoft Excel documents they're going to come times where you send this document out
perhaps to multiple people maybe you know it's people or you drop it on a thumb drive or you you throw
it up on a network drive and people are expected to go out there and view the document.
But I only want specific people to have access to that document.
Well one of the ways that we can do this strictly through Microsoft Excel is by adding a work book password
.
Now users have to have the password in order to open up this document and once again this is another
simple simple feature but a very useful and powerful feature.
Lockdown the document and less you have the password.
Watch this.
So I've got an Excel document open.
This is the exercise file but it really doesn't matter you can open up just a brand new document or
one of your own.
Doesn't matter.
I'm going to go to my File tab.
Top left corner of any file on the info section.
I'm going to go to protect workbook.
I'll give that a click.
You get several options in here.
But one of them is encrypt with password.
I'll give that a click.
I'm going to ask you for your password I'll use password as my password just for demonstrations.
Don't lose it's if you lose it you can't recover it through Excel.
Now OK I got to confirm it to make sure I typed it in right the first time and now my workbook is protected
.
So I'm going to save this I'll hit save and I'll go close it's going to go file down to close.
We'll get rid of that gone and I'm going to reopen it.
So I'm going to re-open excel on my computer get them back over here and them Emond to reopen up the
example file.
And now I need a password so a drop in my password.
OK then I'm now able to reopen that Excel workbook.
That simple underneath file you go into info protect the workbook encrypted with the past remember don't
forget your password you can't recover that keep it someplace secure.
But now in order to open up the document and build a view and make others do it you've got to have that
password.
Now if you want to turn around or remove the password I can go back in the NFL back protect workbook
and if I click on encrypt with password I can remove the password or I'll just delete that out that
password is gone I can resave the document passwords off of there.
We no longer need to protect it in that way.
But whatever it is that you need but it's very simple very powerful very quick feature your file info
will protect the workbook encrypted with the password.
Once again stress it one more time.
Don't forget the password.
You need it you can't recover it.
All right.
Try it out